Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	475740
Missing cells	1427720
Missing cells (%)	15.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	189.6 MiB
Average record size in memory	417.9 B

Variable types

Numeric	13
Categorical	6

Warnings

`Series` has constant value "EQ"	Constant
`Date` has a high cardinality: 5306 distinct values	High cardinality
`Symbol` has a high cardinality: 66 distinct values	High cardinality
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Turnover` is highly correlated with `Trades` and 1 other fields	High correlation
`Trades` is highly correlated with `Turnover` and 1 other fields	High correlation
`Deliverable Volume` is highly correlated with `Turnover` and 1 other fields	High correlation
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Turnover` is highly correlated with `Deliverable Volume`	High correlation
`Deliverable Volume` is highly correlated with `Turnover`	High correlation
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Close` and 6 other fields	High correlation
`Deliverable Volume` is highly correlated with `Turnover` and 1 other fields	High correlation
`df_index` is highly correlated with `Symbol`	High correlation
`Trades` is highly correlated with `Turnover` and 1 other fields	High correlation
`ISIN Code` is highly correlated with `Industry` and 2 other fields	High correlation
`Close` is highly correlated with `High` and 6 other fields	High correlation
`VWAP` is highly correlated with `High` and 6 other fields	High correlation
`%Deliverble` is highly correlated with `Symbol`	High correlation
`Low` is highly correlated with `High` and 6 other fields	High correlation
`Industry` is highly correlated with `ISIN Code` and 2 other fields	High correlation
`Company Name` is highly correlated with `ISIN Code` and 2 other fields	High correlation
`Symbol` is highly correlated with `High` and 11 other fields	High correlation
`Open` is highly correlated with `High` and 6 other fields	High correlation
`Turnover` is highly correlated with `Deliverable Volume` and 1 other fields	High correlation
`Prev Close` is highly correlated with `High` and 6 other fields	High correlation
`Volume` is highly correlated with `Deliverable Volume` and 1 other fields	High correlation
`Last` is highly correlated with `High` and 6 other fields	High correlation
`Series` is highly correlated with `Company Name` and 3 other fields	High correlation
`Company Name` is highly correlated with `Series` and 3 other fields	High correlation
`Industry` is highly correlated with `Series` and 3 other fields	High correlation
`Symbol` is highly correlated with `Series` and 3 other fields	High correlation
`ISIN Code` is highly correlated with `Series` and 3 other fields	High correlation
`Company Name` has 475690 (> 99.9%) missing values	Missing
`Industry` has 475690 (> 99.9%) missing values	Missing
`ISIN Code` has 475690 (> 99.9%) missing values	Missing
`Company Name` is uniformly distributed	Uniform
`ISIN Code` is uniformly distributed	Uniform

Reproduction

Analysis started	2021-08-30 12:32:33.363041
Analysis finished	2021-08-30 12:35:22.082704
Duration	2 minutes and 48.72 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	235192
Distinct (%)	49.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59383.2172

Minimum	0
Maximum	235191
Zeros	52
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	465
Q1	2331
median	5053
Q3	116256.25
95-th percentile	211404.05
Maximum	235191
Range	235191
Interquartile range (IQR)	113925.25

Descriptive statistics

Standard deviation	74787.62299
Coefficient of variation (CV)	1.259406723
Kurtosis	-0.5627300011
Mean	59383.2172
Median Absolute Deviation (MAD)	4809
Skewness	0.9612231003
Sum	2.825097175 × 10¹⁰
Variance	5593188553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	52	< 0.1%
21	52	< 0.1%
20	52	< 0.1%
44	52	< 0.1%
19	52	< 0.1%
45	52	< 0.1%
18	52	< 0.1%
46	52	< 0.1%
17	52	< 0.1%
47	52	< 0.1%
Other values (235182)	475220	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	52	< 0.1%
1	52	< 0.1%
2	52	< 0.1%
3	52	< 0.1%
4	52	< 0.1%
5	52	< 0.1%
6	52	< 0.1%
7	52	< 0.1%
8	52	< 0.1%
9	52	< 0.1%

Value	Count	Frequency (%)
235191	1	< 0.1%
235190	1	< 0.1%
235189	1	< 0.1%
235188	1	< 0.1%
235187	1	< 0.1%
235186	1	< 0.1%
235185	1	< 0.1%
235184	1	< 0.1%
235183	1	< 0.1%
235182	1	< 0.1%

Date
Categorical

HIGH CARDINALITY

Distinct	5306
Distinct (%)	1.1%
Missing	50
Missing (%)	< 0.1%
Memory size	30.4 MiB

2016-11-11	99
2011-01-31	99
2012-05-29	99
2015-11-17	99
2014-11-28	99
Other values (5301)	475195

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	4756900
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2000-01-03
2nd row	2000-01-04
3rd row	2000-01-05
4th row	2000-01-06
5th row	2000-01-07

Common Values

Value	Count	Frequency (%)
2016-11-11	99	< 0.1%
2011-01-31	99	< 0.1%
2012-05-29	99	< 0.1%
2015-11-17	99	< 0.1%
2014-11-28	99	< 0.1%
2012-01-31	99	< 0.1%
2018-10-25	99	< 0.1%
2015-06-16	99	< 0.1%
2014-03-10	99	< 0.1%
2014-04-07	99	< 0.1%
Other values (5296)	474700	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-11-11	99	< 0.1%
2012-06-22	99	< 0.1%
2013-02-06	99	< 0.1%
2013-10-25	99	< 0.1%
2014-12-24	99	< 0.1%
2012-03-14	99	< 0.1%
2020-10-23	99	< 0.1%
2011-10-28	99	< 0.1%
2012-04-26	99	< 0.1%
2018-04-10	99	< 0.1%
Other values (5296)	474700	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	1322344	27.8%
-	951380	20.0%
2	831406	17.5%
1	701967	14.8%
3	155567	3.3%
7	135732	2.9%
8	135101	2.8%
9	132529	2.8%
6	132070	2.8%
5	130732	2.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3805520	80.0%
Dash Punctuation	951380	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1322344	34.7%
2	831406	21.8%
1	701967	18.4%
3	155567	4.1%
7	135732	3.6%
8	135101	3.6%
9	132529	3.5%
6	132070	3.5%
5	130732	3.4%
4	128072	3.4%

Dash Punctuation

Value	Count	Frequency (%)
-	951380	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4756900	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1322344	27.8%
-	951380	20.0%
2	831406	17.5%
1	701967	14.8%
3	155567	3.3%
7	135732	2.9%
8	135101	2.8%
9	132529	2.8%
6	132070	2.8%
5	130732	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4756900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1322344	27.8%
-	951380	20.0%
2	831406	17.5%
1	701967	14.8%
3	155567	3.3%
7	135732	2.9%
8	135101	2.8%
9	132529	2.8%
6	132070	2.8%
5	130732	2.7%

Symbol
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	66
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.0 MiB

CIPLA	10613
IOC	10613
BPCL	10613
ICICIBANK	10613
RELIANCE	10613
Other values (61)	422675

Length

Max length	10
Median length	7
Mean length	6.873708328
Min length	2

Characters and Unicode

Total characters	3270098
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	ZEETELE
2nd row	ZEETELE
3rd row	ZEETELE
4th row	ZEETELE
5th row	ZEETELE

Common Values

Value	Count	Frequency (%)
CIPLA	10613	2.2%
IOC	10613	2.2%
BPCL	10613	2.2%
ICICIBANK	10613	2.2%
RELIANCE	10613	2.2%
GRASIM	10613	2.2%
WIPRO	10613	2.2%
ITC	10613	2.2%
HDFCBANK	10613	2.2%
TITAN	10613	2.2%
Other values (56)	369610	77.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hdfcbank	10613	2.2%
icicibank	10613	2.2%
reliance	10613	2.2%
itc	10613	2.2%
grasim	10613	2.2%
m&m	10613	2.2%
drreddy	10613	2.2%
titan	10613	2.2%
ioc	10613	2.2%
ongc	10613	2.2%
Other values (56)	369610	77.7%

Most occurring characters

Value	Count	Frequency (%)
A	356723	10.9%
I	319358	9.8%
N	258950	7.9%
T	256672	7.8%
E	235830	7.2%
C	224719	6.9%
R	180890	5.5%
O	168123	5.1%
S	160913	4.9%
L	149536	4.6%
Other values (18)	958384	29.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3249242	99.4%
Other Punctuation	10613	0.3%
Dash Punctuation	6405	0.2%
Decimal Number	3838	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	356723	11.0%
I	319358	9.8%
N	258950	8.0%
T	256672	7.9%
E	235830	7.3%
C	224719	6.9%
R	180890	5.6%
O	168123	5.2%
S	160913	5.0%
L	149536	4.6%
Other values (15)	937528	28.9%

Dash Punctuation

Value	Count	Frequency (%)
-	6405	100.0%

Decimal Number

Value	Count	Frequency (%)
0	3838	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	10613	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3249242	99.4%
Common	20856	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	356723	11.0%
I	319358	9.8%
N	258950	8.0%
T	256672	7.9%
E	235830	7.3%
C	224719	6.9%
R	180890	5.6%
O	168123	5.2%
S	160913	5.0%
L	149536	4.6%
Other values (15)	937528	28.9%

Common

Value	Count	Frequency (%)
&	10613	50.9%
-	6405	30.7%
0	3838	18.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3270098	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	356723	10.9%
I	319358	9.8%
N	258950	7.9%
T	256672	7.8%
E	235830	7.2%
C	224719	6.9%
R	180890	5.5%
O	168123	5.1%
S	160913	4.9%
L	149536	4.6%
Other values (18)	958384	29.3%

Series
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.8 MiB

EQ	475740

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	951480
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EQ
2nd row	EQ
3rd row	EQ
4th row	EQ
5th row	EQ

Common Values

Value	Count	Frequency (%)
EQ	475740	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
eq	475740	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	475740	50.0%
Q	475740	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	951480	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	475740	50.0%
Q	475740	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	951480	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	475740	50.0%
Q	475740	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	951480	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	475740	50.0%
Q	475740	50.0%

Prev Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	63729
Distinct (%)	13.4%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1255.122428

Minimum	0
Maximum	32861.95
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	97.25
Q1	271.1
median	558.125
Q3	1230.75
95-th percentile	3944.8
Maximum	32861.95
Range	32861.95
Interquartile range (IQR)	959.65

Descriptive statistics

Standard deviation	2569.114743
Coefficient of variation (CV)	2.046903702
Kurtosis	49.37165031
Mean	1255.122428
Median Absolute Deviation (MAD)	363.175
Skewness	6.308670799
Sum	597049187.6
Variance	6600350.564
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137	67	< 0.1%
140	63	< 0.1%
135	63	< 0.1%
200.15	61	< 0.1%
30	60	< 0.1%
125.2	60	< 0.1%
157.1	60	< 0.1%
270.05	59	< 0.1%
281	58	< 0.1%
112	58	< 0.1%
Other values (63719)	475081	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
2	2	< 0.1%
9.15	2	< 0.1%
9.4	2	< 0.1%
9.5	2	< 0.1%
9.6	2	< 0.1%
9.65	12	< 0.1%
9.75	6	< 0.1%
9.8	4	< 0.1%
9.85	4	< 0.1%

Value	Count	Frequency (%)
32861.95	2	< 0.1%
32766.1	2	< 0.1%
32661.85	2	< 0.1%
32617.75	2	< 0.1%
32498.6	2	< 0.1%
32443.5	2	< 0.1%
32403.95	2	< 0.1%
32371.05	2	< 0.1%
32233.4	2	< 0.1%
32226.4	2	< 0.1%

Open
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	44298
Distinct (%)	9.3%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1256.67471

Minimum	8.5
Maximum	33399.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	8.5
5-th percentile	97.4
Q1	271.5
median	558.7
Q3	1231.15
95-th percentile	3950
Maximum	33399.95
Range	33391.45
Interquartile range (IQR)	959.65

Descriptive statistics

Standard deviation	2572.983975
Coefficient of variation (CV)	2.04745425
Kurtosis	49.42402029
Mean	1256.67471
Median Absolute Deviation (MAD)	363.4
Skewness	6.311702782
Sum	597787592.6
Variance	6620246.537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
340	423	0.1%
370	421	0.1%
330	412	0.1%
350	398	0.1%
290	398	0.1%
315	394	0.1%
360	389	0.1%
260	388	0.1%
345	381	0.1%
270	376	0.1%
Other values (44288)	471710	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8.5	2	< 0.1%
9.5	2	< 0.1%
9.6	2	< 0.1%
9.65	2	< 0.1%
9.75	8	< 0.1%
9.8	4	< 0.1%
9.85	8	< 0.1%
9.9	4	< 0.1%
9.95	4	< 0.1%
10	6	< 0.1%

Value	Count	Frequency (%)
33399.95	2	< 0.1%
32800	2	< 0.1%
32698	2	< 0.1%
32599	2	< 0.1%
32500	4	< 0.1%
32499	2	< 0.1%
32489	2	< 0.1%
32480	2	< 0.1%
32451.5	2	< 0.1%
32301.2	2	< 0.1%

High
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	49036
Distinct (%)	10.3%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1275.34912

Minimum	9.75
Maximum	33480
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	9.75
5-th percentile	99.4
Q1	276
median	568.45
Q3	1250
95-th percentile	3999
Maximum	33480
Range	33470.25
Interquartile range (IQR)	974

Descriptive statistics

Standard deviation	2607.211411
Coefficient of variation (CV)	2.044311923
Kurtosis	49.21476336
Mean	1275.34912
Median Absolute Deviation (MAD)	369.15
Skewness	6.301985792
Sum	606670822.8
Variance	6797551.344
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
360	256	0.1%
375	252	0.1%
350	251	0.1%
330	249	0.1%
275	248	0.1%
370	247	0.1%
315	243	0.1%
355	239	0.1%
280	239	0.1%
305	234	< 0.1%
Other values (49026)	473232	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.75	2	< 0.1%
9.8	8	< 0.1%
9.85	4	< 0.1%
9.9	6	< 0.1%
9.95	2	< 0.1%
10	8	< 0.1%
10.1	4	< 0.1%
10.15	4	< 0.1%
10.2	2	< 0.1%
10.25	2	< 0.1%

Value	Count	Frequency (%)
33480	2	< 0.1%
33328.8	2	< 0.1%
32916.85	2	< 0.1%
32799.2	2	< 0.1%
32766.6	2	< 0.1%
32750	2	< 0.1%
32698.95	2	< 0.1%
32644.95	2	< 0.1%
32604.25	2	< 0.1%
32549	2	< 0.1%

Low
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	51335
Distinct (%)	10.8%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1236.558405

Minimum	8.5
Maximum	32468.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	8.5
5-th percentile	95.25
Q1	266.25
median	549
Q3	1210.25
95-th percentile	3891.05
Maximum	32468.1
Range	32459.6
Interquartile range (IQR)	944

Descriptive statistics

Standard deviation	2534.53152
Coefficient of variation (CV)	2.049665838
Kurtosis	49.53362423
Mean	1236.558405
Median Absolute Deviation (MAD)	357.35
Skewness	6.315493272
Sum	588218467.9
Variance	6423850.027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	274	0.1%
325	263	0.1%
370	252	0.1%
320	251	0.1%
310	244	0.1%
390	240	0.1%
350	239	0.1%
305	230	< 0.1%
260	228	< 0.1%
330	225	< 0.1%
Other values (51325)	473244	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8.5	2	< 0.1%
8.95	2	< 0.1%
9.1	2	< 0.1%
9.15	2	< 0.1%
9.3	2	< 0.1%
9.5	2	< 0.1%
9.55	6	< 0.1%
9.6	6	< 0.1%
9.65	6	< 0.1%
9.7	2	< 0.1%

Value	Count	Frequency (%)
32468.1	2	< 0.1%
32400	2	< 0.1%
32301	2	< 0.1%
32300.05	2	< 0.1%
32300	2	< 0.1%
32290	2	< 0.1%
32200	2	< 0.1%
32136.85	2	< 0.1%
32082.25	2	< 0.1%
31850	2	< 0.1%

Last
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	48570
Distinct (%)	10.2%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1255.309781

Minimum	9.1
Maximum	32849
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	9.1
5-th percentile	97.25
Q1	271.2
median	558
Q3	1231
95-th percentile	3945
Maximum	32849
Range	32839.9
Interquartile range (IQR)	959.8

Descriptive statistics

Standard deviation	2569.138277
Coefficient of variation (CV)	2.046616952
Kurtosis	49.356176
Mean	1255.309781
Median Absolute Deviation (MAD)	363
Skewness	6.307437085
Sum	597138309.7
Variance	6600471.489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	258	0.1%
330	255	0.1%
380	254	0.1%
350	253	0.1%
340	249	0.1%
325	241	0.1%
345	241	0.1%
315	238	0.1%
300	233	< 0.1%
310	229	< 0.1%
Other values (48560)	473239	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.1	2	< 0.1%
9.25	2	< 0.1%
9.5	2	< 0.1%
9.6	8	< 0.1%
9.65	2	< 0.1%
9.7	4	< 0.1%
9.75	2	< 0.1%
9.8	4	< 0.1%
9.85	4	< 0.1%
9.9	4	< 0.1%

Value	Count	Frequency (%)
32849	2	< 0.1%
32760	2	< 0.1%
32600	2	< 0.1%
32598	2	< 0.1%
32520	2	< 0.1%
32450	2	< 0.1%
32430	2	< 0.1%
32420	2	< 0.1%
32208.55	2	< 0.1%
32184	2	< 0.1%

Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	63739
Distinct (%)	13.4%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1255.47453

Minimum	9.15
Maximum	32861.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	9.15
5-th percentile	97.3
Q1	271.15
median	558.3
Q3	1230.95
95-th percentile	3945.35
Maximum	32861.95
Range	32852.8
Interquartile range (IQR)	959.8

Descriptive statistics

Standard deviation	2569.882386
Coefficient of variation (CV)	2.046941077
Kurtosis	49.35739553
Mean	1255.47453
Median Absolute Deviation (MAD)	363.3
Skewness	6.307921552
Sum	597216679
Variance	6604295.476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137	67	< 0.1%
135	63	< 0.1%
140	63	< 0.1%
200.15	61	< 0.1%
125.2	60	< 0.1%
30	60	< 0.1%
157.1	60	< 0.1%
270.05	59	< 0.1%
159.85	58	< 0.1%
112	58	< 0.1%
Other values (63729)	475081	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.15	2	< 0.1%
9.4	2	< 0.1%
9.5	2	< 0.1%
9.6	2	< 0.1%
9.65	12	< 0.1%
9.75	6	< 0.1%
9.8	4	< 0.1%
9.85	4	< 0.1%
9.95	4	< 0.1%
10	4	< 0.1%

Value	Count	Frequency (%)
32861.95	2	< 0.1%
32766.1	2	< 0.1%
32661.85	2	< 0.1%
32617.75	2	< 0.1%
32498.6	2	< 0.1%
32443.5	2	< 0.1%
32403.95	2	< 0.1%
32371.05	2	< 0.1%
32233.4	2	< 0.1%
32226.4	2	< 0.1%

VWAP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	138831
Distinct (%)	29.2%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1256.050425

Minimum	9.21
Maximum	32975.24
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	9.21
5-th percentile	97.4645
Q1	271.34
median	558.4
Q3	1231.17
95-th percentile	3946.8
Maximum	32975.24
Range	32966.03
Interquartile range (IQR)	959.83

Descriptive statistics

Standard deviation	2570.439218
Coefficient of variation (CV)	2.046445881
Kurtosis	49.35536364
Mean	1256.050425
Median Absolute Deviation (MAD)	363.305
Skewness	6.307368685
Sum	597490626.6
Variance	6607157.771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
136.49	25	< 0.1%
277.76	24	< 0.1%
137.07	24	< 0.1%
300.4	23	< 0.1%
259.75	23	< 0.1%
135.35	22	< 0.1%
141.82	22	< 0.1%
186.97	22	< 0.1%
163.02	21	< 0.1%
168.06	21	< 0.1%
Other values (138821)	475463	99.9%
(Missing)	50	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.21	2	< 0.1%
9.45	2	< 0.1%
9.61	2	< 0.1%
9.62	2	< 0.1%
9.65	2	< 0.1%
9.66	2	< 0.1%
9.68	6	< 0.1%
9.72	2	< 0.1%
9.75	2	< 0.1%
9.76	2	< 0.1%

Value	Count	Frequency (%)
32975.24	2	< 0.1%
32882.47	2	< 0.1%
32599.8	2	< 0.1%
32581.18	2	< 0.1%
32556.12	2	< 0.1%
32540.7	2	< 0.1%
32458.75	2	< 0.1%
32437.36	2	< 0.1%
32393.75	2	< 0.1%
32304.71	2	< 0.1%

Volume
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	220434
Distinct (%)	46.3%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3065752.612

Minimum	3
Maximum	481058927
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	3
5-th percentile	10586
Q1	224287
median	1026758
Q3	3038475
95-th percentile	12158159
Maximum	481058927
Range	481058924
Interquartile range (IQR)	2814188

Descriptive statistics

Standard deviation	7349109.321
Coefficient of variation (CV)	2.397163194
Kurtosis	366.0976462
Mean	3065752.612
Median Absolute Deviation (MAD)	952379
Skewness	12.35294776
Sum	1.45834786 × 10¹²
Variance	5.400940781 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	62	< 0.1%
200	48	< 0.1%
1000	42	< 0.1%
500	36	< 0.1%
300	34	< 0.1%
700	34	< 0.1%
900	32	< 0.1%
1400	28	< 0.1%
800	28	< 0.1%
400	28	< 0.1%
Other values (220424)	475318	99.9%
(Missing)	50	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	2	< 0.1%
6	2	< 0.1%
10	2	< 0.1%
25	4	< 0.1%
27	4	< 0.1%
32	2	< 0.1%
33	2	< 0.1%
35	2	< 0.1%
50	8	< 0.1%
51	4	< 0.1%

Value	Count	Frequency (%)
481058927	2	< 0.1%
479716245	2	< 0.1%
390577839	2	< 0.1%
316008609	2	< 0.1%
286857658	2	< 0.1%
286173629	2	< 0.1%
283614463	2	< 0.1%
270968028	2	< 0.1%
265709391	2	< 0.1%
262677081	2	< 0.1%

Turnover
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	236251
Distinct (%)	49.7%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.606111268 × 10¹⁴

Minimum	10470000
Maximum	3.564334168 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	10470000
5-th percentile	3.7745247 × 10¹¹
Q1	1.632697149 × 10¹³
median	6.802326423 × 10¹³
Q3	1.856753031 × 10¹⁴
95-th percentile	5.88649934 × 10¹⁴
Maximum	3.564334168 × 10¹⁶
Range	3.564334167 × 10¹⁶
Interquartile range (IQR)	1.693483316 × 10¹⁴

Descriptive statistics

Standard deviation	3.288006109 × 10¹⁴
Coefficient of variation (CV)	2.04718451
Kurtosis	912.6613985
Mean	1.606111268 × 10¹⁴
Median Absolute Deviation (MAD)	6.204383775 × 10¹³
Skewness	16.14879937
Sum	7.640110689 × 10¹⁹
Variance	1.081098417 × 10²⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.291994716 × 10¹³	5	< 0.1%
260000000	4	< 0.1%
297500000	4	< 0.1%
4527840000	4	< 0.1%
275000000	4	< 0.1%
1535000000	4	< 0.1%
1.8760005 × 10¹¹	4	< 0.1%
280000000	4	< 0.1%
1.665872142 × 10¹³	3	< 0.1%
3.413466802 × 10¹⁴	3	< 0.1%
Other values (236241)	475651	> 99.9%
(Missing)	50	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10470000	2	< 0.1%
25700000	2	< 0.1%
27900000	2	< 0.1%
63000000	2	< 0.1%
88450000	2	< 0.1%
95950000	2	< 0.1%
97500000	2	< 0.1%
156300000	2	< 0.1%
177500000	2	< 0.1%
179500000	2	< 0.1%

Value	Count	Frequency (%)
3.564334168 × 10¹⁶	2	< 0.1%
2.481773122 × 10¹⁶	2	< 0.1%
1.570039582 × 10¹⁶	2	< 0.1%
1.498221906 × 10¹⁶	2	< 0.1%
1.473433631 × 10¹⁶	2	< 0.1%
1.461958918 × 10¹⁶	2	< 0.1%
1.426399959 × 10¹⁶	2	< 0.1%
1.268361556 × 10¹⁶	2	< 0.1%
1.236079553 × 10¹⁶	2	< 0.1%
1.184668763 × 10¹⁶	2	< 0.1%

Trades
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	79162
Distinct (%)	16.6%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	62980.19751

Minimum	11
Maximum	1643015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	11
5-th percentile	7411
Q1	37069.25
median	61964.27098
Q3	65386
95-th percentile	145230.6409
Maximum	1643015
Range	1643004
Interquartile range (IQR)	28316.75

Descriptive statistics

Standard deviation	52112.14655
Coefficient of variation (CV)	0.8274370137
Kurtosis	56.68163002
Mean	62980.19751
Median Absolute Deviation (MAD)	19592.27098
Skewness	4.9989478
Sum	2.995905015 × 10¹⁰
Variance	2715675818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
61964.27098	114848	24.1%
62645.70928	5700	1.2%
138367.6274	2850	0.6%
82923.62541	2850	0.6%
111849.0301	2850	0.6%
37121.1873	2850	0.6%
78354.90879	2850	0.6%
120602.2317	2850	0.6%
150702.7675	2850	0.6%
55511.07003	2850	0.6%
Other values (79152)	332342	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	2	< 0.1%
16	2	< 0.1%
18	2	< 0.1%
20	2	< 0.1%
21	2	< 0.1%
24	2	< 0.1%
26	2	< 0.1%
27	2	< 0.1%
28	4	< 0.1%
30	2	< 0.1%

Value	Count	Frequency (%)
1643015	2	< 0.1%
1428490	2	< 0.1%
1424793	2	< 0.1%
1318669	2	< 0.1%
1303825	2	< 0.1%
1285533	2	< 0.1%
1233053	2	< 0.1%
1205984	2	< 0.1%
1201928	2	< 0.1%
1194059	2	< 0.1%

Deliverable Volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	200001
Distinct (%)	42.0%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1319019.123

Minimum	5
Maximum	232530747
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	5
5-th percentile	9831
Q1	143455
median	570927
Q3	1426126
95-th percentile	4945056
Maximum	232530747
Range	232530742
Interquartile range (IQR)	1282671

Descriptive statistics

Standard deviation	2733060.883
Coefficient of variation (CV)	2.072040379
Kurtosis	987.5542677
Mean	1319019.123
Median Absolute Deviation (MAD)	514847
Skewness	19.09900594
Sum	6.274442065 × 10¹¹
Variance	7.46962179 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1315098.408	16077	3.4%
1415717.628	1038	0.2%
999465.3974	528	0.1%
2551708.554	525	0.1%
4183406.037	517	0.1%
1331770.503	515	0.1%
4571757.617	514	0.1%
440876.3015	514	0.1%
1550749.808	514	0.1%
2280885.189	514	0.1%
Other values (199991)	454434	95.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	2	< 0.1%
6	2	< 0.1%
17	2	< 0.1%
25	6	< 0.1%
30	2	< 0.1%
32	2	< 0.1%
50	2	< 0.1%
54	2	< 0.1%
57	2	< 0.1%
58	2	< 0.1%

Value	Count	Frequency (%)
232530747	2	< 0.1%
216377820	2	< 0.1%
187584905	2	< 0.1%
185656354	2	< 0.1%
181390171	2	< 0.1%
170946275	2	< 0.1%
148313109	2	< 0.1%
139943805	2	< 0.1%
139345365	2	< 0.1%
135572090	2	< 0.1%

%Deliverble
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9638
Distinct (%)	2.0%
Missing	50
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.5022203801

Minimum	0.0236
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0.0236
5-th percentile	0.1863
Q1	0.3728
median	0.5029968487
Q3	0.6294
95-th percentile	0.8029
Maximum	1
Range	0.9764
Interquartile range (IQR)	0.2566

Descriptive statistics

Standard deviation	0.184320399
Coefficient of variation (CV)	0.3670109902
Kurtosis	-0.3812012965
Mean	0.5022203801
Median Absolute Deviation (MAD)	0.1280968487
Skewness	-0.02155004166
Sum	238901.2126
Variance	0.03397400948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5029968487	16077	3.4%
0.4522112597	1038	0.2%
0.5562428213	528	0.1%
0.4340255386	525	0.1%
0.4734629777	517	0.1%
0.6031712795	515	0.1%
0.4350394407	514	0.1%
0.591634328	514	0.1%
0.5092087855	514	0.1%
0.3679444491	514	0.1%
Other values (9628)	454434	95.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0236	2	< 0.1%
0.0279	2	< 0.1%
0.0283	2	< 0.1%
0.0294	2	< 0.1%
0.0299	4	< 0.1%
0.0318	2	< 0.1%
0.0326	2	< 0.1%
0.0328	2	< 0.1%
0.0343	4	< 0.1%
0.0358	2	< 0.1%

Value	Count	Frequency (%)
1	189	< 0.1%
0.9998	2	< 0.1%
0.9997	4	< 0.1%
0.9996	10	< 0.1%
0.9995	6	< 0.1%
0.9993	2	< 0.1%
0.9992	6	< 0.1%
0.999	1	< 0.1%
0.999	1	< 0.1%
0.9989	2	< 0.1%

Company Name
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING
UNIFORM

Distinct	50
Distinct (%)	100.0%
Missing	475690
Missing (%)	> 99.9%
Memory size	14.5 MiB

Larsen & Toubro Ltd.	1
NTPC Ltd.	1
Indian Oil Corporation Ltd.	1
Bharti Airtel Ltd.	1
UltraTech Cement Ltd.	1
Other values (45)	45

Length

Max length	44
Median length	18
Mean length	20.66
Min length	8

Characters and Unicode

Total characters	1033
Distinct characters	54
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	50 ?
Unique (%)	100.0%

Sample

1st row	Adani Ports and Special Economic Zone Ltd.
2nd row	Asian Paints Ltd.
3rd row	Axis Bank Ltd.
4th row	Bajaj Auto Ltd.
5th row	Bajaj Finserv Ltd.

Common Values

Value	Count	Frequency (%)
Larsen & Toubro Ltd.	1	< 0.1%
NTPC Ltd.	1	< 0.1%
Indian Oil Corporation Ltd.	1	< 0.1%
Bharti Airtel Ltd.	1	< 0.1%
UltraTech Cement Ltd.	1	< 0.1%
HDFC Bank Ltd.	1	< 0.1%
Nestle India Ltd.	1	< 0.1%
Kotak Mahindra Bank Ltd.	1	< 0.1%
IndusInd Bank Ltd.	1	< 0.1%
Coal India Ltd.	1	< 0.1%
Other values (40)	40	< 0.1%
(Missing)	475690	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ltd	49	29.5%
india	6	3.6%
bank	6	3.6%
corporation	5	3.0%
industries	5	3.0%
mahindra	4	2.4%
	3	1.8%
bajaj	3	1.8%
tata	3	1.8%
bharti	2	1.2%
Other values (74)	80	48.2%

Most occurring characters

Value	Count	Frequency (%)
	116	11.2%
t	97	9.4%
a	77	7.5%
d	75	7.3%
n	66	6.4%
i	56	5.4%
e	54	5.2%
L	54	5.2%
r	52	5.0%
.	50	4.8%
Other values (44)	336	32.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	677	65.5%
Uppercase Letter	184	17.8%
Space Separator	116	11.2%
Other Punctuation	54	5.2%
Open Punctuation	1	0.1%
Close Punctuation	1	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	97	14.3%
a	77	11.4%
d	75	11.1%
n	66	9.7%
i	56	8.3%
e	54	8.0%
r	52	7.7%
o	47	6.9%
s	33	4.9%
l	20	3.0%
Other values (15)	100	14.8%

Uppercase Letter

Value	Count	Frequency (%)
L	54	29.3%
I	21	11.4%
C	18	9.8%
B	13	7.1%
T	10	5.4%
S	9	4.9%
M	8	4.3%
P	7	3.8%
A	6	3.3%
H	6	3.3%
Other values (13)	32	17.4%

Other Punctuation

Value	Count	Frequency (%)
.	50	92.6%
&	3	5.6%
'	1	1.9%

Space Separator

Value	Count	Frequency (%)
	116	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	861	83.3%
Common	172	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	97	11.3%
a	77	8.9%
d	75	8.7%
n	66	7.7%
i	56	6.5%
e	54	6.3%
L	54	6.3%
r	52	6.0%
o	47	5.5%
s	33	3.8%
Other values (38)	250	29.0%

Common

Value	Count	Frequency (%)
	116	67.4%
.	50	29.1%
&	3	1.7%
'	1	0.6%
(	1	0.6%
)	1	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1033	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	116	11.2%
t	97	9.4%
a	77	7.5%
d	75	7.3%
n	66	6.4%
i	56	5.4%
e	54	5.2%
L	54	5.2%
r	52	5.0%
.	50	4.8%
Other values (44)	336	32.5%

Industry
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	26.0%
Missing	475690
Missing (%)	> 99.9%
Memory size	14.5 MiB

FINANCIAL SERVICES	9
ENERGY	7
CONSUMER GOODS	6
AUTOMOBILE	6
METALS	5
Other values (8)	17

Length

Max length	24
Median length	10
Mean length	11.14
Min length	2

Characters and Unicode

Total characters	557
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	8.0%

Sample

1st row	SERVICES
2nd row	CONSUMER GOODS
3rd row	FINANCIAL SERVICES
4th row	AUTOMOBILE
5th row	FINANCIAL SERVICES

Common Values

Value	Count	Frequency (%)
FINANCIAL SERVICES	9	< 0.1%
ENERGY	7	< 0.1%
CONSUMER GOODS	6	< 0.1%
AUTOMOBILE	6	< 0.1%
METALS	5	< 0.1%
IT	5	< 0.1%
CEMENT & CEMENT PRODUCTS	3	< 0.1%
PHARMA	3	< 0.1%
TELECOM	2	< 0.1%
SERVICES	1	< 0.1%
Other values (3)	3	< 0.1%
(Missing)	475690	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
services	10	12.8%
financial	9	11.5%
energy	7	9.0%
goods	6	7.7%
consumer	6	7.7%
automobile	6	7.7%
cement	6	7.7%
metals	5	6.4%
it	5	6.4%
	5	6.4%
Other values (8)	13	16.7%

Most occurring characters

Value	Count	Frequency (%)
E	75	13.5%
I	46	8.3%
S	45	8.1%
N	42	7.5%
C	39	7.0%
O	37	6.6%
A	37	6.6%
T	34	6.1%
R	33	5.9%
M	30	5.4%
Other values (12)	139	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	524	94.1%
Space Separator	28	5.0%
Other Punctuation	5	0.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	75	14.3%
I	46	8.8%
S	45	8.6%
N	42	8.0%
C	39	7.4%
O	37	7.1%
A	37	7.1%
T	34	6.5%
R	33	6.3%
M	30	5.7%
Other values (10)	106	20.2%

Space Separator

Value	Count	Frequency (%)
	28	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	524	94.1%
Common	33	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	75	14.3%
I	46	8.8%
S	45	8.6%
N	42	8.0%
C	39	7.4%
O	37	7.1%
A	37	7.1%
T	34	6.5%
R	33	6.3%
M	30	5.7%
Other values (10)	106	20.2%

Common

Value	Count	Frequency (%)
	28	84.8%
&	5	15.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	557	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	75	13.5%
I	46	8.3%
S	45	8.1%
N	42	7.5%
C	39	7.0%
O	37	6.6%
A	37	6.6%
T	34	6.1%
R	33	5.9%
M	30	5.4%
Other values (12)	139	25.0%

ISIN Code
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING
UNIFORM

Distinct	50
Distinct (%)	100.0%
Missing	475690
Missing (%)	> 99.9%
Memory size	14.5 MiB

INE001A01036	1
INE075A01022	1
INE019A01038	1
INE213A01029	1
INE481G01011	1
Other values (45)	45

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	600
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	50 ?
Unique (%)	100.0%

Sample

1st row	INE742F01042
2nd row	INE021A01026
3rd row	INE238A01034
4th row	INE917I01010
5th row	INE918I01018

Common Values

Value	Count	Frequency (%)
INE001A01036	1	< 0.1%
INE075A01022	1	< 0.1%
INE019A01038	1	< 0.1%
INE213A01029	1	< 0.1%
INE481G01011	1	< 0.1%
INE628A01036	1	< 0.1%
INE216A01030	1	< 0.1%
INE918I01018	1	< 0.1%
INE129A01019	1	< 0.1%
INE205A01025	1	< 0.1%
Other values (40)	40	< 0.1%
(Missing)	475690	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ine752e01010	1	2.0%
ine239a01016	1	2.0%
ine062a01020	1	2.0%
ine237a01028	1	2.0%
ine522f01014	1	2.0%
ine021a01026	1	2.0%
ine213a01029	1	2.0%
ine075a01022	1	2.0%
ine917i01010	1	2.0%
ine154a01025	1	2.0%
Other values (40)	40	80.0%

Most occurring characters

Value	Count	Frequency (%)
0	141	23.5%
1	90	15.0%
I	52	8.7%
E	52	8.7%
N	50	8.3%
2	50	8.3%
A	38	6.3%
6	20	3.3%
3	20	3.3%
8	18	3.0%
Other values (10)	69	11.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	400	66.7%
Uppercase Letter	200	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	52	26.0%
E	52	26.0%
N	50	25.0%
A	38	19.0%
F	2	1.0%
B	2	1.0%
D	1	0.5%
J	1	0.5%
C	1	0.5%
G	1	0.5%

Decimal Number

Value	Count	Frequency (%)
0	141	35.2%
1	90	22.5%
2	50	12.5%
6	20	5.0%
3	20	5.0%
8	18	4.5%
9	17	4.2%
5	16	4.0%
4	15	3.8%
7	13	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	400	66.7%
Latin	200	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	52	26.0%
E	52	26.0%
N	50	25.0%
A	38	19.0%
F	2	1.0%
B	2	1.0%
D	1	0.5%
J	1	0.5%
C	1	0.5%
G	1	0.5%

Common

Value	Count	Frequency (%)
0	141	35.2%
1	90	22.5%
2	50	12.5%
6	20	5.0%
3	20	5.0%
8	18	4.5%
9	17	4.2%
5	16	4.0%
4	15	3.8%
7	13	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	600	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	141	23.5%
1	90	15.0%
I	52	8.7%
E	52	8.7%
N	50	8.3%
2	50	8.3%
A	38	6.3%
6	20	3.3%
3	20	3.3%
8	18	3.0%
Other values (10)	69	11.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble	Company Name	Industry	ISIN Code
0	0	2000-01-03	ZEETELE	EQ	1092.55	1175.00	1179.95	1160.00	1179.95	1179.95	1177.03	1261391	1.484690e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
1	1	2000-01-04	ZEETELE	EQ	1179.95	1220.00	1274.35	1183.10	1274.35	1260.65	1228.02	4616547	5.669220e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
2	2	2000-01-05	ZEETELE	EQ	1260.65	1160.55	1317.70	1159.80	1190.95	1176.55	1238.35	8763127	1.085178e+15	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
3	3	2000-01-06	ZEETELE	EQ	1176.55	1195.00	1200.00	1095.00	1106.00	1115.45	1135.04	5164020	5.861353e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
4	4	2000-01-07	ZEETELE	EQ	1115.45	1097.10	1097.10	1026.25	1026.25	1026.25	1029.94	755129	7.777374e+13	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
5	5	2000-01-10	ZEETELE	EQ	1026.25	1026.25	1026.25	944.30	962.00	966.70	980.49	3942813	3.865885e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
6	6	2000-01-11	ZEETELE	EQ	966.70	985.00	1044.00	891.00	1018.80	1019.95	995.97	6802005	6.774605e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
7	7	2000-01-12	ZEETELE	EQ	1019.95	1035.00	1088.00	1035.00	1064.00	1063.85	1068.99	2968833	3.173653e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
8	8	2000-01-13	ZEETELE	EQ	1063.85	1073.00	1085.00	1012.70	1018.00	1023.10	1050.57	2251046	2.364882e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN
9	9	2000-01-14	ZEETELE	EQ	1023.10	1030.00	1034.75	980.70	1001.00	1001.85	1007.74	2949092	2.971906e+14	62645.709283	1.415718e+06	0.452211	NaN	NaN	NaN

Last rows

	df_index	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble	Company Name	Industry	ISIN Code
475730	5296	2021-04-16	ZEEL	EQ	189.20	189.2	196.90	189.20	196.35	193.95	193.14	7952202	1.535854e+14	52127.0	1962297.0	0.2468	NaN	NaN	NaN
475731	5297	2021-04-19	ZEEL	EQ	193.95	187.0	191.20	185.10	191.00	190.35	188.28	9346956	1.759879e+14	58935.0	1270493.0	0.1359	NaN	NaN	NaN
475732	5298	2021-04-20	ZEEL	EQ	190.35	193.0	201.75	192.20	197.30	197.40	197.17	15709132	3.097437e+14	77021.0	3089894.0	0.1967	NaN	NaN	NaN
475733	5299	2021-04-22	ZEEL	EQ	197.40	195.5	199.80	191.70	192.15	192.30	194.76	10203121	1.987114e+14	70603.0	2930009.0	0.2872	NaN	NaN	NaN
475734	5300	2021-04-23	ZEEL	EQ	192.30	192.0	193.00	187.00	188.00	188.00	190.04	8529439	1.620902e+14	60790.0	2148300.0	0.2519	NaN	NaN	NaN
475735	5301	2021-04-26	ZEEL	EQ	188.00	190.6	191.10	185.10	186.70	186.40	187.35	8542755	1.600451e+14	52374.0	2340188.0	0.2739	NaN	NaN	NaN
475736	5302	2021-04-27	ZEEL	EQ	186.40	188.0	192.95	186.80	188.80	188.15	189.41	14247767	2.698636e+14	73673.0	5425957.0	0.3808	NaN	NaN	NaN
475737	5303	2021-04-28	ZEEL	EQ	188.15	188.8	190.60	187.10	188.95	189.10	188.85	8429439	1.591917e+14	44056.0	2413974.0	0.2864	NaN	NaN	NaN
475738	5304	2021-04-29	ZEEL	EQ	189.10	190.8	191.65	186.00	186.60	186.55	187.44	9483009	1.777471e+14	60932.0	2744472.0	0.2894	NaN	NaN	NaN
475739	5305	2021-04-30	ZEEL	EQ	186.55	185.3	190.95	183.65	185.00	185.60	187.53	11435285	2.144440e+14	62607.0	3323909.0	0.2907	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Dash Punctuation

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters